TABLE ACCESS CLUSTER
Short Description
Retrieves rows from a clustered table
Detailed Description​
Retrieves rows from a clustered table. Table clusters are groups of tables that share a common columns and store related data in the same block. When clustered, a single data block can contain data from more than one table. Typical access will be to look up a row in the cluster index, then the TABLE ACCESS CLUSTER will read the table data.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.